<?php
class ProductsController extends AppController {
	public $name = 'Products';
	public $uses=array('Product','ProductCategory','ProductImage','FriendlyUrl');
	
	function admin_index(){
		//get filter field
		$filterField=array(				
			$this->uses[0].'.name'=>_resource('name',true),
		);
		
		$this->set('filterField',$filterField);
		//set list cac country name ra view
		if($this->webConfig['is_multi_lang'])
			$this->set('listLang',$this->Common->listCountry());
		//===================================================================
		$this->set('data1',$this->admin_getList());
		$this->render('admin_index','ajax');
	}	
	
	function admin_lists(){
		//khoi tao cac session can thiet cho 1 model, session nay dung de luu lai trang thai cua 1 model nhu phan trang, sort tang giam, dieu kien search, id cha...
		//cac su dung Session cua cakephp : doc them trong book.cakephp.org
		if(!$this->Session->check($this->uses[0])){
			//khoi tao array vao bien $tmp
			$tmp=array(
				'limit'=>$this->webConfig['default_row_per_page'],
				'conditions'=>'',
				'fields'=>null,
				'order'=>$this->uses[0].'.id desc',
				'page'=>1,
				'recursive'=>0,
				'sortField'=>null,
				'sortDir'=>'asc',				
				'filterField'=>'',
				'filterText'=>'',
				'catid'=>'',
			);
			//luu vao session
			$this->Session->write($this->uses[0],$tmp);			
		}
		
		
		$this->{$this->uses[0]}->locale=$this->Session->read('adminLang');
		//doc ra cac trang thai cua 1 model da luu trong session
		// truyen vao bien paginate, khi lay data, model se dua vao cac gia tri cua bien nay de search, sort, phan trang ... 
		$this->paginate=$this->Session->read($this->uses[0]);	
		//t($this->paginate);	
		//ham paginate() la ham ho tro phan trang, khi dung ham nay, se tu dong phan trang theo cac gia tri trong bien paginate o tren
		//lay data da duoc phan trang va truyen vao bien $data0
		$data0=$this->paginate($this->uses[0]);
		//t($data0);
		//su dung khi site co chuc nang da ngon ngu==========================
		//duyet qua tat ca cac rows trong $data0 de kiem tra xem data cua rows da co ngon ngu nao roi.
		if($this->webConfig['is_multi_lang']){
			foreach($data0 as $k=>$v){
				$data0[$k]['Langs']=$this->getLangs($v[$this->uses[0]]['id'],$this->uses[0]);
			}
			$this->set('listLang',$this->Common->listCountry());
		}
		//t($data0);
		//===================================================================
		//set bien $data0 ra view de hien ra luoi.
		$this->set('data0',$data0);
		
		
		//render view va cho cakephp biet day la view cua ajax -> khi do, cakephp se chi render view ma khong render toan bo layout cua website. 
		$this->render('admin_lists','ajax');
	}
	
	function admin_add($locale=null){
		//su dung khi site co chuc nang da ngon ngu==========================
		//neu khong truyen vao ngon ngu thi ngon ngu mac dinh cua data duoc them vao se la ngon ngu duoc doc tu session
		if(!$locale){
			$locale=$this->Session->read('adminLang');
		}
		//khai bao ngon ngu cua model, khi do, ngon ngu cua data duoc luu vao database la $locale 
		$this->{$this->uses[0]}->locale=$locale;
		//====================================================================		
		$this->{$this->uses[0]}->recursive=0;
		$name_error=_resource('can not be null',true);		
		$isInsert=false;
		if(!empty($this->data)){
			$data=$this->data;
			$data[$this->uses[0]][$this->{$this->uses[0]}->belongsTo[$this->uses[1]]['foreignKey']]=$this->Session->read($this->uses[0].'.catid');
			if($this->{$this->uses[0]}->create($data) && $this->{$this->uses[0]}->validates()){				
				if($this->{$this->uses[0]}->save($data)) {
					//================seo link add
					$lastinsertId=$this->{$this->uses[0]}->getLastInsertID();
					$this->updateSeoLink('/products/detail/'.$lastinsertId, $this->data[$this->uses[0]]['name'], $lastinsertId);
					$this->Common->updateCacheRoute();
					
					//=======================
					$this->data=null;					
					$isInsert=true;
					$this->Session->write('message',_resource('insert data successful',true));
				} else {
					$this->Session->write('error',_resource('can not insert data',true));
				}
			}else{
				$this->Session->write('error',_resource('red fill is require',true));
			}
		}
		
		//======================
		//set bien locale ra view de su dung
		$this->set('locale',$locale);
		if($this->webConfig['is_multi_lang'])
			$this->set('listLang',$this->Common->listCountry());
		
		$this->set('isInsert',$isInsert);
		$this->set('name_error',$name_error);		
	}

	function admin_edit($id=null,$locale=null){	
		if(!$locale){
			$locale=$this->Session->read('adminLang');
		}
		$this->{$this->uses[0]}->locale=$locale;	
		$name_error=_resource('can not be null',true);		
		$isInsert=false;
		$this->{$this->uses[0]}->recursive=0;
		if(!empty($this->data)){
			//t($this->data);
			if($this->{$this->uses[0]}->create($this->data) && $this->{$this->uses[0]}->validates()){				
				if($this->{$this->uses[0]}->save($this->data)) {
					
					//=================seo link update
					$this->updateSeoLink('/products/detail/'.$this->data[$this->uses[0]]['id'], $this->data[$this->uses[0]]['name'], $this->data[$this->uses[0]]['id']);
					$this->Common->updateCacheRoute();
					//=======================================
					$this->data=null;					
					$isInsert=true;
					$this->Session->write('message',_resource('update data successful',true));					
				} else {
					$this->Session->write('error',_resource('can not update data',true));
				}
			}else{
				$this->Session->write('error',_resource('red fill is require',true));
			}
		}else{
			if($id!=null){

				//get data from default language
				if($this->{$this->uses[0]}->locale!=$this->Session->read('adminLang') && $this->webConfig['is_multi_lang']){
					$this->{$this->uses[0]}->locale=$this->Session->read('adminLang');
					$defaultdata =$this->{$this->uses[0]}->read(null,$id);
					//t($this->data);
					$this->{$this->uses[0]}->locale=$locale;
					$data =$this->{$this->uses[0]}->read(null,$id);
					
					//get data of current select language
					foreach($this->{$this->uses[0]}->actsAs['Translate'] as $k=>$v){
						$defaultdata[$this->uses[0]]['default'.$v]=$defaultdata[$this->uses[0]][$v];
						$defaultdata[$this->uses[0]][$v]=$data[$this->uses[0]][$v];
					}
					$data=$defaultdata;					
				}
				else{
					
					$data =$this->{$this->uses[0]}->read(null,$id);
					
				}
				$data[$this->uses[0]]['oldimage']=$data[$this->uses[0]]['image'];
				$this->data=$data;
				if(empty($this->data)){	
					$this->Session->write('error',_resource('data not found',true));				
					$this->render('admin_editNotFound');
				}
			}
			else{				
				$this->Session->write('error',_resource('data not found',true));		
				$this->render('admin_edit_not_found');
			}
		}	

		
		
		//set bien locale ra view de su dung
		$this->set('locale',$locale);
		if($this->webConfig['is_multi_lang'])
			$this->set('listLang',$this->Common->listCountry());
		$this->set('data1',$this->admin_getList());
		$this->set('isInsert',$isInsert);
		$this->set('name_error',$name_error);
		
	}
	
	function admin_gallery($id=null,$locale=null){	
		if(!$locale){
			$locale=$this->Session->read('adminLang');
		}
		$id=intval($id);
		$this->{$this->uses[0]}->locale=$locale;
		$this->{$this->uses[2]}->locale=$locale;				
		$name_error=_resource('can not be null',true);		
		$isInsert=false;
		$this->{$this->uses[0]}->recursive=0;
		$data=$this->{$this->uses[0]}->read(null,$id);
		if(empty($data)){
			$this->Session->write('error',_resource('data not found',true));		
			$this->render('admin_edit_not_found');
			return;
		}
		if(!empty($this->data)){	
			if(isset($this->data[$this->uses[2]]['title']) && count($this->data[$this->uses[2]]['title'])>0){
				foreach($this->data[$this->uses[2]]['title'] as $k=>$v){
					$img=$this->{$this->uses[2]}->find('first',array('conditions'=>array($this->uses[2].'.image'=>$k)));
					$img[$this->uses[2]]['title']=$v;
					$this->{$this->uses[2]}->save($img);
					
				}
			}		
			$isInsert=true;			
		}else{
			$this->data=$data;
			$data =$this->{$this->uses[2]}->find('all',array('conditions'=>array('image_category_id'=>$id)));
			$this->set('imgdata',$data);		
			
		}	

		
		
		//set bien locale ra view de su dung
		$this->set('locale',$locale);
		if($this->webConfig['is_multi_lang'])
			$this->set('listLang',$this->Common->listCountry());
		$this->set('id',$id);
		$this->set('isInsert',$isInsert);
		$this->set('name_error',$name_error);
		
	}

	function admin_delete($id = null) {		
		$this->Session->delete('error');
		//if is submit:		
		if($this->request->is('post')){
			$id_arr=$this->data['check'];
		} else {
			$id_arr=null;
		}
		//if url
		if(intval($id)){
			$id_arr[$id]='';
		}
		if(count($id_arr)>0){
			//Xoa nhieu record
			$this->{$this->uses[0]}->query('delete from '.$this->{$this->uses[0]}->tablePrefix.$this->{$this->uses[0]}->table.' where id in ('.implode(',',array_keys($id_arr)).')' );			
		} else {
			$this->Session->write('error',_resource('no information to delete',true));
		}
		$this->admin_lists();		
	}
	
	function admin_published($id=null,$value=1,$field=0){
	$id_arr=null;
		$all=false;		
		switch($field){
			case 1: $fieldname='best';break;
			case 2: $fieldname='bestbuy';break;
			default: $fieldname='published';
		}
		if((!intval($value) && $value!=0) || intval($value)>1){
			$value=1;
		}
		
		//if is submit:		
		if($this->request->is('post')){
			$id_arr=$this->data['check'];
			$all=true;
		} 
		
		//if url
		if(intval($id) && !$all){
			$id_arr[$id]='';
		}
		
		if(count($id_arr)>0){			
			$this->{$this->uses[0]}->query('update '.$this->{$this->uses[0]}->tablePrefix.$this->{$this->uses[0]}->table.' set '.$fieldname.'='.$value.' where id in ('.implode(',',array_keys($id_arr)).')' );
		}
		if (!$all) {			
			$this->set('value',$value);
			$this->set('field',$field);
			$this->set('fieldname',$fieldname);
			$this->set('id',intval($id));
			$this->render('admin_published','ajax');		
		} else {
			$this->admin_lists();
		}
		
	}
	
	function admin_sort($sortField=null,$sortDir='asc'){
		if($sortField){
			if($sortDir!='desc') $sortDir='asc';
			$this->Session->write($this->uses[0].'.sortField',$sortField);
			$this->Session->write($this->uses[0].'.sortDir',$sortDir);
			$this->Session->write($this->uses[0].'.order',$sortField.' '.$sortDir);
		}
		$this->admin_lists();
	}
	
	function admin_page($page=1){
		$this->Session->write($this->uses[0].'.page',$page);
		$this->admin_lists();
	}
	
	function admin_display($limit=0){
		if(intval($limit)){
			$this->Session->write($this->uses[0].'.limit',$limit);
		}
		$this->admin_lists();
	}

	function admin_filter(){
		if($this->request->is('post')){
			$this->Session->write($this->uses[0].'.filterText',$this->request->data['filter_text']);
			$this->Session->write($this->uses[0].'.filterField',$this->request->data['filter_field']);
			//$conditions=$this->Session->read($this->uses[0].'.conditions');
			if(!empty($this->request->data['filter_text'])){				
				$conditions[$this->request->data['filter_field'].' like']='%'.$this->request->data['filter_text'].'%';
				$this->Session->write($this->uses[0].'.page',1);				
			}
			else{
				unset($conditions[$this->request->data['filter_field'].' like']);
			}
			
			$this->Session->write($this->uses[0].'.conditions',$conditions);
		}
		$this->admin_lists();
	}
	
	/*
	 * ham dung de save thu tu cua tung mau tin
	 */
	function admin_save(){
		if(isset($this->params['form']['order'])){			
			foreach($this->params['form']['order'] as $k=>$v){
				if(intval($v)){
					//set view order for category
					$this->{$this->uses[0]}->updateAll(array($this->uses[0].'.view_order'=>intval($v)),array($this->uses[0].'.id'=>$k));
				}
			}
		}
		$this->Session->write('message',_resource('view order has been update',true));
		$this->admin_lists();
	}
	function admin_getList($locale=null){
		$rt=array();
		$this->{$this->uses[1]}->locale=$this->Session->read('adminLang');
		$data=$this->{$this->uses[1]}->find('all');
		foreach($data as $k=>$v){
			$rt[$v[$this->uses[1]]['id']]=$v[$this->uses[1]]['name'];
		}
		return $rt;
		
	}
	function admin_selCat($id=null,$newpage=1) {
		//kiem tra neu submit tu form
		//luu dieu kien chon
		$conditions=null;
		$conditions=$this->Session->read($this->uses[0].'.conditions');
		$conditions[$this->uses[0].'.'.$this->{$this->uses[0]}->belongsTo[$this->uses[1]]['foreignKey']]=intval($id);
		if($id!=null){
			//luu sesssion de giu lai gia da chon
			$this->Session->write($this->uses[0].'.catid',intval($id));
		}
		else{
			$this->Session->write($this->uses[0].'.catid','');
			unset($conditions[$this->uses[0].'.'.$this->{$this->uses[0]}->belongsTo[$this->uses[1]]['foreignKey']]);
		}
		$this->Session->write($this->uses[0].'.conditions',$conditions);
		if($newpage)$this->admin_index();
		else $this->admin_lists();
	}
	
/*
	 * ham dung khi co su dung chuc nang da ngon ngu
	 * dung de change locale cua he thong
	 * tham so truyen vao la locale cua ngon ngu
	 */
	function admin_changeLocale($locale=null){
		//luu session
		if($locale){
			$this->Session->write('adminLang',$locale);
		}
		//reload lai luoi de apply locale vua change
		$this->admin_lists();
	}
	
	function detail($id=null){
		$this->layout='default';
		
		$this->set('css','productdetail');
		$this->{$this->uses[0]}->locale=$this->Session->read('siteLang');
		$this->{$this->uses[1]}->recursive=0;
		$id=intval($id);
		
		
		$data=$this->{$this->uses[0]}->find('first',array('conditions'=>$this->uses[0].'.id='.$id.' and '.$this->uses[0].'.published=1'));
		if(isset($data[$this->uses[0]]['id'])){
			$gallerydata=$this->{$this->uses[2]}->find('list',array('conditions'=>$this->uses[2].'.image_category_id='.$data[$this->uses[0]]['id'].' and '.$this->uses[2].'.published=1','fields'=>array('title','image')));
			$this->set('gallerydata',$gallerydata);	
			$this->set('title_for_layout',$data[$this->uses[0]]['name']);
			
			//$prevdata=$this->{$this->uses[0]}->find('first',array('conditions'=>$this->uses[0].'.image_category_id='.$data[$this->uses[0]]['image_category_id'].' and '.$this->uses[0].'.id<'.$id.' and '.$this->uses[0].'.published=1','order'=>$this->uses[0].'.id desc'));
			//$nextdata=$this->{$this->uses[0]}->find('first',array('conditions'=>$this->uses[0].'.image_category_id='.$data[$this->uses[0]]['image_category_id'].' and '.$this->uses[0].'.id>'.$id.' and '.$this->uses[0].'.published=1'));
			//if(!empty($prevdata))$this->set('prevdata',$prevdata);
			//if(!empty($nextdata))$this->set('nextdata',$nextdata);
			//meta for fb
			$this->set('ogTitle',$data[$this->uses[0]]['name']);
			$this->set('ogType','Article');
			$this->set('ogDescription',$data[$this->uses[0]]['description']);
			$this->set('ogUrl','/products/detail/'.$data[$this->uses[0]]['id']);
			$this->set('ogImage',SITE_URL.'/uploaded/Product/thumb/'.$data[$this->uses[0]]['image']);
					
			$this->set('data',$data);
			//$this->set('catdata',$catdata);
			$data0=$this->{$this->uses[0]}->find('all',array('conditions'=>$this->uses[0].'.id<>'.$data[$this->uses[0]]['id'].' and '.$this->uses[0].'.product_category_id='.$data[$this->uses[0]]['product_category_id'].' and '.$this->uses[0].'.published=1','order'=>$this->uses[0].'.id desc','limit'=>$this->webConfig['orther_product_page']));
			//t($data0);
			//set bien $data0 ra view de hien ra luoi.
			$this->set('data0',$data0);
		}
		else{
			$this->redirect('/product_categories');
		}
	}

function index($cid=1){
		$this->layout='default';		
		$this->set('css','product');
		$this->{$this->uses[0]}->locale=$this->Session->read('siteLang');
		$this->{$this->uses[1]}->locale=$this->Session->read('siteLang');
		$this->{$this->uses[0]}->recursive=-1;
		$this->{$this->uses[1]}->recursive=-1;
		$cid=intval($cid);
		$data=$this->{$this->uses[1]}->find('first',array('conditions'=>$this->uses[1].'.published=1 and '.$this->uses[1].'.id='.$cid));
		$data0=$this->{$this->uses[0]}->find('all',array('conditions'=>$this->uses[0].'.published=1 and '.$this->uses[0].'.product_category_id='.$cid));
		if(!isset($data[$this->uses[1]]['id']) || !isset($data0[0][$this->uses[0]]['id']) ){
			$this->redirect(SITE_URL.'/product_categories');			
		}
		$this->set('title_for_layout',$data[$this->uses[1]]['name']);
		$this->set('data0',$data0);
		$this->set('data',$data);
		

	}

}
?>
